Usage Note 65884: The ability to connect to a Google BigQuery database via proxy has been added to the SAS/ACCESS® Interface to Google BigQuery
The ability to connect to a Google BigQuery database via a proxy is available with this hot fix. You can use the newly added option, PROXY=, with the following methods of connection to the Google BigQuery database:
LIBNAME GBQ BIGQUERY PROXY="<proxy_url>"...;
PROC SQL; CONNECT TO BIGQUERY(PROXY="<proxy_url>"...);
PROC FEDSQL NOLIB CONN=(DRIVER=FEDSQL;CONOPTS=(DRIVER=BIGQUERY;PROXY="<proxy_url>";...));
CASLIB GBQ DATASOURCE=(srctype="bigquery", PROXY="<proxy_url>",...);
Currently, after you make a connection to a BigQuery database (once the gbqgo.so library has been loaded), you cannot alter the PROXY= option without restarting the SAS session. This behavior includes when you add the PROXY= option after you attempted a prior connection to the BigQuery database without the option.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.41 | 9.42 | 9.4 TS1M6 | 9.4 TS1M7 |
| SAS System | SAS Data Connector to Google BigQuery | Linux for x64 | V.03.05 | 2020.1.1 | Viya | Viya |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Date Modified: | 2020-04-30 11:50:08 |
| Date Created: | 2020-04-27 15:21:50 |